CREATE TABLE [dbo].[Job]
(
[JobId] [int] NOT NULL IDENTITY(1, 1),
[CountryId] [int] NOT NULL,
[RegionId] [int] NULL,
[CityId] [int] NOT NULL,
[FullName] [nvarchar] (400) COLLATE Cyrillic_General_CI_AS NOT NULL,
[Abbreviation] [nvarchar] (100) COLLATE Cyrillic_General_CI_AS NULL,
[IsVisible] [bit] NOT NULL,
[IsDeleted] [bit] NOT NULL,
[CreateDate] [datetime] NOT NULL,
[LastModifiedDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Job] ADD CONSTRAINT [PK_Job_1] PRIMARY KEY CLUSTERED  ([JobId]) ON [PRIMARY]
GO
